You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
CALLIOSTOMA SPESA |
15.00 | |
PRINOVOLVA WILSONIANA |
4.00 | |
CLITHON CORONA |
4.00 | |
LYRIA VICDANI |
20.00 | |
RANSONIELLA PUNCTATA GLANDINA |
6.00 | |
CYPRAEA TIGRIS |
8.00 | |
HALIOTIS VARIA |
6.00 | |
BABELOMUREX WORMALDI |
50.00 | |
CYMBIOLACCA WISEMANI RANDALLI |
70.00 | |
MITRELLA GERVILLEI |
3.00 | |
LYRIA SOLANGEAE |
140.00 | |
CONUS TEREBRA |
12.00 | |
CYPRAEA TIGRIS |
8.00 | |
CYPRAEA TIGRIS |
12.00 | |
CONUS XIMENES |
15.00 | |
CYPRAEA TIGRIS |
80.00 | |
BABELOMUREX WORMALDI |
30.00 | |
LYRIA SOLANGEAE |
120.00 | |
PARAMETARIA DUPONTII |
4.00 | |
CHICOREUS TERRITUS |
8.00 | |
CALLISTA UMBONELLA |
25.00 | |
SOLENOSTERIA CALOOSANA |
8.00 | |
Total: | 648.00 |